StudentNsldsSummary

EntityType | Independent
Logical Entity Name | StudentNsldsSummary
Default Table Name | FaNSLDSStudent
Logical Only | NO
Owner | dbo
Definition |
Note |

StudentNsldsSummary Attributes

Attribute/Logical Rolename | Domain | Datatype | NULL | Definition
StudentEnrollmentPeriodId |  | INTEGER | YES |
Id |  | INTEGER | NO |
StudentId |  | INTEGER | NO |
AwardYear |  | CHAR(7) | NO |
SchoolCode |  | CHAR(8) | YES |
AmountScheduled |  | MONEY(19, 4) | YES |
AmountDisbursed |  | MONEY(19, 4) | YES |
BeginDate |  | DATETIME | YES |
EndDate |  | DATETIME | YES |
GradeLevel |  | VARCHAR(2) | YES |
GrantType |  | VARCHAR(8) | YES |
LastModifiedUserId |  | INTEGER | NO |
CreatedDateTime |  | DATETIME | NO |
LastModifiedDateTime |  | DATETIME | NO |
RowVersion |  | TIMESTAMP/DATE | NO |
AggregateSubsidizedBalance |  | MONEY(19, 4) | YES |
AggregateUnsubsidizedBalance |  | MONEY(19, 4) | YES |
AggregateCombinedBalance |  | MONEY(19, 4) | YES |
NumberWeeksInPreviousAcademicYear |  | SMALLINT | YES |
OverlapPeriodStartDate |  | DATETIME | YES |
OverlapPeriodEndDate |  | DATETIME | YES |
IsSulaFlag |  | BIT | NO |
SLEU |  | NUMERIC(6, 3) | YES |
StubWeeks |  | INTEGER | YES |
StubUnits |  | NUMERIC(7, 2) | YES |
IsAeiFlag |  | BIT | NO |
PriorPercentageDisbursed |  | MONEY(19, 4) | YES |

StudentNsldsSummary Keys

Key Name | Key Type | Keys
FaNSLDSStudent_UserID_N_N_IDX | Inversion Entry | LastModifiedUserId
FaNSLDSStudent_SyStudentID_N_N_IDX | Inversion Entry | StudentId
Pk_FaNSLDSStudent_FaNSLDSStudentID | PrimaryKey | Id
nk_FaNSLDSStudent_AdEnrollID | Inversion Entry | StudentEnrollmentPeriodId

StudentNsldsSummary Relationships

Parent Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype
StudentEnrollmentPeriod | Non-Identifying | Zero or One to Zero or More |  |  |  | StudentEnrollmentPeriodId | NO
Student | Non-Identifying | One To Zero or More |  |  |  | StudentId | NO
Staff | Non-Identifying | One To Zero or More |  |  |  | LastModifiedUserId | NO

Child Relationships:

Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype

StudentNsldsSummary Check Constraints

Check Constraint Name | CheckConstraint

StudentNsldsSummary Where Used - Model Usage

Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments
Logical dbo.StudentNsldsSummary | NO |  |  |
Physical (Microsoft SQL Server) dbo.FaNSLDSStudent | NO |  |  |

StudentNsldsSummary Where Used - Submodel Usage

Model | Submodel Usage
Logical | Main Model
Physical (Microsoft SQL Server) | Main Model
Physical (Microsoft SQL Server) | Financial Aid

StudentNsldsSummary Data Movement Rules

Name | Type | Rule Text/Value